<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
	<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=iso-8859-1">
	<TITLE>Dataxi tour page 4</TITLE>
	<META NAME="GENERATOR" CONTENT="OpenOffice.org 1.0.2  (Linux)">
	<META NAME="AUTHOR" CONTENT="Jyry Kuukkanen">
	<META NAME="CREATED" CONTENT="20030716;15232500">
	<META NAME="CHANGED" CONTENT="20030716;15234100">
</HEAD>
<BODY LANG="en-GB">
<H1>Querying</H1>
<P>If you opened the &quot;Countries&quot; from the &quot;Example
menu&quot;, this is what you<SPAN LANG="en-GB"> should </SPAN>see.</P>
<P><IMG SRC="countriesq.png" NAME="Graphic1" ALT="Countries - query mode" ALIGN=BOTTOM WIDTH=686 HEIGHT=513 BORDER=0>
</P>
<P>The menu stays the same throughout the application, but a small
form with two columns (fields) in it has opened up in the workplace
and navigator bas got few buttons to press.</P>
<P>Someone has managed to type <B>e*</B> in the &quot;Code&quot; in
order to search for countries whose code begins with E. 
</P>
<H3>Query mode</H3>
<P>There are few modes to operate in with form. The most used &nbsp;of
them is query that allows you to search the database by typing search
conditions in fields you want to limit the search results by. Common
condition are greater than (e.g. &quot;&gt;5&quot; means &quot;this
field value found in database must be greater than 5&quot;), not
equal to (e.g. &quot;&lt;&gt;alpha&quot; means &quot;this field value
can be anything but a string 'alpha'&quot;) and<SPAN LANG="en-GB">
wild cards </SPAN>(e.g. &quot;E*D&quot; means &quot;this field must
start with E and end with D, but there can be as many characters
between them. 'England' would match this just fine&quot;).</P>
<P>If you want to get the same screen that's shown in the next page,
type in <B>e*</B> or <B>E*</B> in the Code box. and click [Commit]
button in the navigator bar.</P>
<P><A HREF="tour05.html">Click here to the next page -&gt;</A></P>
<P><BR><BR>
</P>
</BODY>
</HTML>